Publishing with or without interactivity

If you want users to view the data you publish but not work with it in the browser, you can publish it as noninteractive data. You can open, edit and save noninteractive Web pages in Microsoft Excel, but you cannot make any changes to the data in the browser.

• Be sure the Add interactivity with check box under Viewing options is cleared.

• For a filtered list, Web page viewers can see only the data that was not filtered when you published the list. However, all data in the list is published to the Web page. Filtered (hidden) data can be viewed by viewing the HTML source code for the page.

• You cannot publish an entire workbook without interactivity in the Publish dialog box. Instead, click Save As Web Page on the File menu, and instead of clicking Publish, select Entire Workbook in the Save as Web Page dialog box and make sure the Add interactivity box is cleared.

To enable people to work with the data on your Web page in a browser, you can make your data interactive. For example, you can publish an interactive spreadsheet that calculates loan information. A user who browses to the page can enter financial information such as loan amount and interest rate to calculate a monthly payment.

• Select the Add interactivity with check box and select the type of interactivity you want from the list. The type of interactivity that's available depends on what you are publishing. For example:

  • For a worksheet that contains formulas, select Spreadsheet functionality so that users of your Web page can enter new values in a cell and the formulas will automatically calculate the results.

  • For a PivotTable report, select PivotTable functionality so that users of your Web page can change the layout of rows and columns to see different summaries of the source data.

  • For an external data range, select PivotTable functionality so that Web page viewers can update the data from its source.

  • For a filtered list, select Spreadsheet functionality.

  • For a chart or PivotChart report, select Chart functionality. If you try to publish all contents of a worksheet that contains a chart with interactive functionality, the chart is not included on the Web page. To put an interactive chart on a Web page, you must publish the chart separately.

  Notes

  • Browser users must have Microsoft Internet Explorer 4.1 or later and an appropriate Microsoft Office license to work with spreadsheets, charts, or PivotTable lists published interactively from Microsoft Excel.

  • You cannot open and modify interactive Web pages in Excel, so it's a good idea to save a copy of the original workbook from which you publish in case you want to make changes in Excel and republish.